A field attribute that automatically stores a unique number for each record as it is added to a table. An AutoNumber field uses the Long data type and has its Attributes property set to dbAutoIncrement. Numbers generated by an AutoNumber field cannot be modified unless special permission has been granted to the table through either the Grant or Revoke statements in SQL DDL syntax. The AutoNumber field is also known as a Counter or Identity data type.
Note For replicated tables in replicated databases, an AutoNumber field is not incremented by 1. Instead, it is assigned a random value between -2,000,000,000 and 2,000,000,000.
See Also